The Save button adds items to the database after performing a number of verification checks. If items are not contained on the database they will be inserted and a message displayed indicating such. If an item is found on the database when the insert is attempted a message is returned indicating the action taken by the insert request. Screen views show before and after images when updating database with Save.
When song, artist and media data is inserted to the database a reference linking their relationship will be generated and stored in the reference table. The reference table allows different views of the song/artist and song/media relationships.
The Media Company field identifies the company that released the Media Title. Media Company is not required but when used adds an improved the level of separation for media. (Ex: If multiple artist release an album with the title 'Greatest Hits' and the company value is not provided the songs on all albums with that title would be listed together.)
The drop down listbox to the right of artist allows an instrument to be associated with that artist and the drop down listbox to the right of media allows a recorded source to be associated with that Media title. Drop down listbox selections are informational only.
When entering multiple songs for an artist and media combination long pressing the Save button will retain the artist and media values from the last insert.